CREATE TABLE [dbo].[tb_Normas]
(
[idNorma] [int] NOT NULL IDENTITY(1, 1),
[Descripcion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TipoNorma] [int] NULL,
[SeImprimio] [int] NOT NULL CONSTRAINT [DF_tb_Normas_SeImprimio] DEFAULT ((0)),
[Organizacion] [int] NULL,
[FechaDeCarga] [datetime] NULL CONSTRAINT [DF_tb_Normas_FechaDeCarga] DEFAULT (getdate()),
[Comentario] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TipoDeMovimiento] [int] NULL,
[Rectificatoria] [bit] NULL,
[Usuario] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Normas] ADD CONSTRAINT [PK_tb_Normas] PRIMARY KEY CLUSTERED  ([idNorma]) WITH (FILLFACTOR=95) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Normas] WITH NOCHECK ADD CONSTRAINT [FK_tb_Normas_tb_TiposDeNormas] FOREIGN KEY ([TipoNorma]) REFERENCES [dbo].[tb_TiposDeNormas] ([idTipoNorma])
GO
